SET ODPS.SQL.DECIMAL.ODPS2 = TRUE;
CREATE TABLE ${tableInfo.tableName}(
<#list tableFields as tableField>
    <#if (tableField.columnName)??&&(tableField.columnName == "DATA_ID")>
        ${tableField.columnName} ${tableField.dataType}(${tableField.dataLength}) NOT NULL <#if tableField.columnComment??> COMMENT '${tableField.columnComment}'</#if>
    <#elseif (tableField.columnName == "DATA_DATE")>
    <#elseif ((tableField.dataScale)?? && tableField.dataScale gt 0)&&(tableField.fieldType == "DECIMAL" || tableField.fieldType == "NUMBER" || tableField.fieldType == "NUMERIC")>
        ,${tableField.columnName} ${tableField.dataType}(${tableField.dataLength},${tableField.dataScale}) <#if tableField.columnComment??> COMMENT '${tableField.columnComment}'</#if>
    <#elseif tableField.dataType?contains("int")>
        ,${tableField.columnName} ${tableField.dataType} <#if tableField.columnComment??> COMMENT '${tableField.columnComment}'</#if>
    <#else>
        ,${tableField.columnName} ${tableField.dataType}(${tableField.dataLength}) <#if tableField.columnComment??> COMMENT '${tableField.columnComment}'</#if>
    </#if>
</#list>
)<#if tableInfo.tableComment??>COMMENT '${tableInfo.tableComment}'</#if> PARTITIONED BY (DATA_DATE VARCHAR(100) COMMENT '数据日期');